package com.ejoysoft.wlanyz.business; 

import com.ejoysoft.common.DbConnect;
import com.ejoysoft.common.Globa;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import java.util.Vector;


public class Carriers {

    private Globa globa;
    private DbConnect db;

    //构造方法
    public Carriers() {
    }

    public Carriers(Globa globa) {
        this.globa = globa;
        db = globa.db;
    }

    //构造方法 
    public Carriers(Globa globa, boolean b) {
        this.globa = globa;
        db = globa.db;
        if (b) globa.setDynamicProperty(this);
    }
    public Carriers show(String where) {
        try {
            String strSql = "select * from  " + strTableName + "  ".concat(where);
            ResultSet rs = db.executeQuery(strSql);
            if (rs != null && rs.next())
                return load(rs, true);
            else
                return null;
        } catch (Exception ee) {
            return null;
        }
    }
    public Carriers load(ResultSet rs, boolean isView) {
    	Carriers theBean = new Carriers();
	        try {
	            theBean.setStrId(rs.getString("strId"));
	            theBean.setStrTaskId(rs.getString("strTaskId"));
	            theBean.setStrCommunityId(rs.getString("strCommunityId"));
	            theBean.setStrNeiCommunityId(rs.getString("strNeiCommunityId"));
	            
	            theBean.setStrText(rs.getString("strText"));
	            theBean.setIntAp_Relevacy_Sucrate(rs.getDouble("intAp_Relevacy_Sucrate"));
	            theBean.setIntAp_Relevacy_Delay(rs.getDouble("intAp_Relevacy_Delay"));
	            theBean.setIntWeb_Auth_Sucrate(rs.getDouble("intWeb_Auth_Sucrate"));
	            theBean.setIntWeb_Off_Sucrate(rs.getDouble("intWeb_Off_Sucrate"));
	            
	            theBean.setIntPeap_Auth_Sucrate(rs.getDouble("intPeap_Auth_Sucrate"));
	            theBean.setIntPeap_Off_Sucrate(rs.getDouble("intPeap_Off_Sucrate"));
	            theBean.setIntHttp_Req_Sucrate(rs.getDouble("intHttp_Req_Sucrate"));
	            theBean.setIntPing_Sucrate(rs.getDouble("intPing_Sucrate"));
	            theBean.setIntFtp_Up_Sucrate(rs.getDouble("intFtp_Up_Sucrate"));
	            
	            theBean.setIntFtp_Down_Sucrate(rs.getDouble("intFtp_Down_Sucrate"));
	            theBean.setIntUser_Seg_Sucrate(rs.getDouble("intUser_Seg_Sucrate"));
	            theBean.setIntUser_Roam_Sucrate(rs.getDouble("intUser_Roam_Sucrate"));
	            theBean.setIntWeb_Up_Delay(rs.getDouble("intWeb_Up_Delay"));
	            theBean.setIntWeb_Down_Delay(rs.getDouble("intWeb_Down_Delay"));
	            
	            theBean.setIntPeap_Up_Delay(rs.getDouble("intPeap_Up_Delay"));
	            theBean.setIntHttp_Resp_Delay(rs.getDouble("intHttp_Resp_Delay"));
	            theBean.setIntPing_Delay(rs.getDouble("intPing_Delay"));
	            theBean.setIntFtp_Up_Speed(rs.getDouble("intFtp_Up_Speed"));
	            theBean.setIntFtp_Down_Speed(rs.getDouble("intFtp_Down_Speed"));
	            
	            theBean.setIntAp_Corr_Suc_Counts(rs.getDouble("intAp_Corr_Suc_Counts"));
	            theBean.setIntAp_Corr_Total_Counts(rs.getDouble("intAp_Corr_Total_Counts"));
	            theBean.setIntWeb_Auth_Suc_Counts(rs.getDouble("intWeb_Auth_Suc_Counts"));
	            theBean.setIntWeb_Auth_Total_Counts(rs.getDouble("intWeb_Auth_Total_Counts"));
	            theBean.setIntWeb_Off_Suc_Counts(rs.getDouble("intWeb_Off_Suc_Counts"));
	           
	            theBean.setIntWeb_Off_Total_Counts(rs.getDouble("intWeb_Off_Total_Counts"));
	            theBean.setIntPeap_Auth_Suc_Counts(rs.getDouble("intPeap_Auth_Suc_Counts"));
	            theBean.setIntPeap_Auth_Total_Counts(rs.getDouble("intPeap_Auth_Total_Counts"));
	            theBean.setIntPeap_Off_Suc_Counts(rs.getDouble("intPeap_Off_Suc_Counts"));
	            theBean.setIntPeap_Off_Total_Counts(rs.getDouble("intPeap_Off_Total_Counts"));
	            
	            
	            theBean.setIntHttp_Req_Suc_Counts(rs.getDouble("intHttp_Req_Suc_Counts"));
	            theBean.setIntHttp_Req_Total_Counts(rs.getDouble("intHttp_Req_Total_Counts"));
	            theBean.setIntFtp_Up_Suc_Counts(rs.getDouble("intFtp_Up_Suc_Counts"));
	            theBean.setIntFtp_UP_Total_Counts(rs.getDouble("intFtp_UP_Total_Counts"));
	            theBean.setIntFtp_Down_Suc_Counts(rs.getDouble("intFtp_Down_Suc_Counts"));
	            
	            
	            theBean.setIntFtp_Down_Total_Counts(rs.getDouble("intFtp_Down_Total_Counts"));
	            theBean.setIntUser_Seg_Suc_Counts(rs.getDouble("intUser_Seg_Suc_Counts"));
	            theBean.setIntUser_Seg_Total_Counts(rs.getDouble("intUser_Seg_Total_Counts"));
	            theBean.setIntUser_Roam_Suc_Counts(rs.getDouble("intUser_Roam_Suc_Counts"));
	            theBean.setIntUser_Roam_Total_Counts(rs.getDouble("intUser_Roam_Total_Counts"));
	            
	            
	            theBean.setStrApMac(rs.getString("strApMac"));
	            theBean.setStrNetType(rs.getString("strNetType"));
	            theBean.setDtCreatDate(rs.getString("dtCreatDate"));
	            theBean.setStrCarriers(rs.getString("strCarriers"));
	            theBean.setIntRssi(rs.getDouble("intRssi"));

	        } catch (Exception e) {
	            e.printStackTrace();
	        }
	        return theBean;
	    }
    public Carriers load1(ResultSet rs,String strStartTime, String strEndTime) {
    	Carriers theBean = new Carriers();
    	 try {
	            theBean.setStrId(rs.getString("strId"));
	            theBean.setStrTaskId(rs.getString("strTaskId"));
	            theBean.setStrCommunityId(rs.getString("strCommunityId"));
	            theBean.setStrNeiCommunityId(rs.getString("strNeiCommunityId"));
	            
	            theBean.setStrText(rs.getString("strText"));
	            theBean.setIntAp_Relevacy_Sucrate(rs.getDouble("intAp_Relevacy_Sucrate"));
	            theBean.setIntAp_Relevacy_Delay(rs.getDouble("intAp_Relevacy_Delay"));
	            theBean.setIntWeb_Auth_Sucrate(rs.getDouble("intWeb_Auth_Sucrate"));
	            theBean.setIntWeb_Off_Sucrate(rs.getDouble("intWeb_Off_Sucrate"));
	            
	            theBean.setIntPeap_Auth_Sucrate(rs.getDouble("intPeap_Auth_Sucrate"));
	            theBean.setIntPeap_Off_Sucrate(rs.getDouble("intPeap_Off_Sucrate"));
	            theBean.setIntHttp_Req_Sucrate(rs.getDouble("intHttp_Req_Sucrate"));
	            theBean.setIntPing_Sucrate(rs.getDouble("intPing_Sucrate"));
	            theBean.setIntFtp_Up_Sucrate(rs.getDouble("intFtp_Up_Sucrate"));
	            
	            theBean.setIntFtp_Down_Sucrate(rs.getDouble("intFtp_Down_Sucrate"));
	            theBean.setIntUser_Seg_Sucrate(rs.getDouble("intUser_Seg_Sucrate"));
	            theBean.setIntUser_Roam_Sucrate(rs.getDouble("intUser_Roam_Sucrate"));
	            theBean.setIntWeb_Up_Delay(rs.getDouble("intWeb_Up_Delay"));
	            theBean.setIntWeb_Down_Delay(rs.getDouble("intWeb_Down_Delay"));
	            
	            theBean.setIntPeap_Up_Delay(rs.getDouble("intPeap_Up_Delay"));
	            theBean.setIntHttp_Resp_Delay(rs.getDouble("intHttp_Resp_Delay"));
	            theBean.setIntPing_Delay(rs.getDouble("intPing_Delay"));
	            theBean.setIntFtp_Up_Speed(rs.getDouble("intFtp_Up_Speed"));
	            theBean.setIntFtp_Down_Speed(rs.getDouble("intFtp_Down_Speed"));
	            
	            theBean.setIntAp_Corr_Suc_Counts(rs.getDouble("intAp_Corr_Suc_Counts"));
	            theBean.setIntAp_Corr_Total_Counts(rs.getDouble("intAp_Corr_Total_Counts"));
	            theBean.setIntWeb_Auth_Suc_Counts(rs.getDouble("intWeb_Auth_Suc_Counts"));
	            theBean.setIntWeb_Auth_Total_Counts(rs.getDouble("intWeb_Auth_Total_Counts"));
	            theBean.setIntWeb_Off_Suc_Counts(rs.getDouble("intWeb_Off_Suc_Counts"));
	           
	            theBean.setIntWeb_Off_Total_Counts(rs.getDouble("intWeb_Off_Total_Counts"));
	            theBean.setIntPeap_Auth_Suc_Counts(rs.getDouble("intPeap_Auth_Suc_Counts"));
	            theBean.setIntPeap_Auth_Total_Counts(rs.getDouble("intPeap_Auth_Total_Counts"));
	            theBean.setIntPeap_Off_Suc_Counts(rs.getDouble("intPeap_Off_Suc_Counts"));
	            theBean.setIntPeap_Off_Total_Counts(rs.getDouble("intPeap_Off_Total_Counts"));
	            
	            
	            theBean.setIntHttp_Req_Suc_Counts(rs.getDouble("intHttp_Req_Suc_Counts"));
	            theBean.setIntHttp_Req_Total_Counts(rs.getDouble("intHttp_Req_Total_Counts"));
	            theBean.setIntFtp_Up_Suc_Counts(rs.getDouble("intFtp_Up_Suc_Counts"));
	            theBean.setIntFtp_UP_Total_Counts(rs.getDouble("intFtp_UP_Total_Counts"));
	            theBean.setIntFtp_Down_Suc_Counts(rs.getDouble("intFtp_Down_Suc_Counts"));
	            
	            
	            theBean.setIntFtp_Down_Total_Counts(rs.getDouble("intFtp_Down_Total_Counts"));
	            theBean.setIntUser_Seg_Suc_Counts(rs.getDouble("intUser_Seg_Suc_Counts"));
	            theBean.setIntUser_Seg_Total_Counts(rs.getDouble("intUser_Seg_Total_Counts"));
	            theBean.setIntUser_Roam_Suc_Counts(rs.getDouble("intUser_Roam_Suc_Counts"));
	            theBean.setIntUser_Roam_Total_Counts(rs.getDouble("intUser_Roam_Total_Counts"));
	            theBean.setIntRssi(rs.getDouble("intRssi"));
	            
	            theBean.setStrApMac(rs.getString("strApMac"));
	            theBean.setStrNetType(rs.getString("strNetType"));
	            theBean.setDtCreatDate(rs.getString("dtCreatDate"));
	            theBean.setStrCarriers(rs.getString("strCarriers"));
	            

	        } catch (Exception e) {
	            e.printStackTrace();
	        }
	        return theBean;
	    }
    public Vector<Carriers> list2(String where, int startRow, int rowCount,String strStartTime,String strEndTime) {
		Vector<Carriers> beans = new Vector<Carriers>();
		if(strStartTime.equals(""))strStartTime = "1000-1-01";
        if(strEndTime.equals(""))strEndTime = "9999-12-30";
        try {
            String sql = "select wlan_test_result.strId,wlan_test_result.strTaskId,wlan_test_result.strCommunityId,wlan_test_result.strNeiCommunityId," +
            		"wlan_test_result.strText,wlan_test_result.intAp_Relevacy_Sucrate,wlan_test_result.intAp_Relevacy_Delay,wlan_test_result.intWeb_Auth_Sucrate," +
            		"wlan_test_result.intWeb_Off_Sucrate,wlan_test_result.intPeap_Auth_Sucrate,wlan_test_result.intPeap_Off_Sucrate,wlan_test_result.intHttp_Req_Sucrate," +
            		"wlan_test_result.intPing_Sucrate,wlan_test_result.intFtp_Up_Sucrate,wlan_test_result.intFtp_Down_Sucrate,wlan_test_result.intUser_Seg_Sucrate," +
            		"wlan_test_result.intUser_Roam_Sucrate,wlan_test_result.intWeb_Up_Delay,wlan_test_result.intWeb_Down_Delay,wlan_test_result.intPeap_Up_Delay," +
            		"wlan_test_result.intHttp_Resp_Delay,wlan_test_result.intPing_Delay,wlan_test_result.intFtp_Up_Speed,wlan_test_result.intFtp_Down_Speed,wlan_test_result.intAp_Corr_Suc_Counts," +
            		"wlan_test_result.intAp_Corr_Total_Counts,wlan_test_result.intWeb_Auth_Suc_Counts,wlan_test_result.intWeb_Auth_Total_Counts,wlan_test_result.intWeb_Off_Suc_Counts,wlan_test_result.intWeb_Off_Total_Counts," +
            		"wlan_test_result.intPeap_Auth_Suc_Counts,wlan_test_result.intPeap_Auth_Total_Counts,wlan_test_result.intPeap_Off_Suc_Counts,wlan_test_result.intPeap_Off_Total_Counts,wlan_test_result.intHttp_Req_Suc_Counts," +
            		"wlan_test_result.intHttp_Req_Total_Counts,wlan_test_result.intFtp_Up_Suc_Counts,wlan_test_result.intFtp_UP_Total_Counts,wlan_test_result.intFtp_Down_Suc_Counts,wlan_test_result.intFtp_Down_Total_Counts,wlan_test_result.intUser_Seg_Suc_Counts,wlan_test_result.intUser_Seg_Total_Counts," +
            		"wlan_test_result.intUser_Roam_Suc_Counts,wlan_test_result.intUser_Roam_Total_Counts,wlan_test_result.strApMac,wlan_test_result.strNetType,wlan_test_result.dtCreatDate,wlan_test_result.strCarriers,wlan_test_result.intRssi from wlan_resc_comunity, wlan_test_result,wlan_task_info,wlan_resc_hotpot where wlan_resc_comunity.strcommid = wlan_test_result.strcommunityid and wlan_test_result.strtaskid=wlan_task_info.strtaskid and wlan_task_info.strhotpotname=wlan_resc_hotpot.strid"+ "".concat(where);
           
            strStartTime="to_date('" + strStartTime + "','yyyy-MM-dd hh24.mi.ss') ";
    	    strEndTime="to_date('" + strEndTime + "','yyyy-MM-dd hh24.mi.ss') ";
    		sql = sql.concat(" and wlan_task_info.dtStartTime>=" + strStartTime).concat(" and wlan_task_info.dtEndTime<=" + strEndTime);
            Statement s = db.getConnection().createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            if (startRow != 0 && rowCount != 0)
                s.setMaxRows((startRow + rowCount) - 1);
            ResultSet rs = s.executeQuery(sql);
            if (rs != null && rs.next()) {
                if (startRow != 0 && rowCount != 0)
                    rs.absolute(startRow);
                do {
                	Carriers theBean = new Carriers();
                    theBean = load1(rs, strStartTime,strEndTime);
                    beans.addElement(theBean);
                } while (rs.next());
            }
            rs.close();
            s.close();
        } catch (Exception ee) {
            ee.printStackTrace();
        }
        return beans;
    }
    
    public Vector<Carriers> list(String where, int startRow, int rowCount) {
		Vector<Carriers> beans = new Vector<Carriers>();
        try {
            String sql = "select * from " +strTableName+"  ".concat(where); 
          
            Statement s = db.getConnection().createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            if (startRow != 0 && rowCount != 0)
                s.setMaxRows((startRow + rowCount) - 1);
            ResultSet rs = s.executeQuery(sql);
            if (rs != null && rs.next()) {
                if (startRow != 0 && rowCount != 0)
                    rs.absolute(startRow);
                do {
                	Carriers theBean = new Carriers();
                    theBean = load(rs, false);
                    beans.addElement(theBean);
                } while (rs.next());
            }
            rs.close();
            s.close();
        } catch (Exception ee) {
            ee.printStackTrace();
        }
        return beans;
    }
    public Vector<Carriers> list1(String where, int startRow, int rowCount) {
		Vector<Carriers> beans = new Vector<Carriers>();
        try {
            String sql = "select wlan_test_result.strId,wlan_test_result.strTaskId,wlan_test_result.strCommunityId,wlan_test_result.strNeiCommunityId," +
            		"wlan_test_result.strText,wlan_test_result.intAp_Relevacy_Sucrate,wlan_test_result.intAp_Relevacy_Delay,wlan_test_result.intWeb_Auth_Sucrate," +
            		"wlan_test_result.intWeb_Off_Sucrate,wlan_test_result.intPeap_Auth_Sucrate,wlan_test_result.intPeap_Off_Sucrate,wlan_test_result.intHttp_Req_Sucrate," +
            		"wlan_test_result.intPing_Sucrate,wlan_test_result.intFtp_Up_Sucrate,wlan_test_result.intFtp_Down_Sucrate,wlan_test_result.intUser_Seg_Sucrate," +
            		"wlan_test_result.intUser_Roam_Sucrate,wlan_test_result.intWeb_Up_Delay,wlan_test_result.intWeb_Down_Delay,wlan_test_result.intPeap_Up_Delay," +
            		"wlan_test_result.intHttp_Resp_Delay,wlan_test_result.intPing_Delay,wlan_test_result.intFtp_Up_Speed,wlan_test_result.intFtp_Down_Speed,wlan_test_result.intAp_Corr_Suc_Counts," +
            		"wlan_test_result.intAp_Corr_Total_Counts,wlan_test_result.intWeb_Auth_Suc_Counts,wlan_test_result.intWeb_Auth_Total_Counts,wlan_test_result.intWeb_Off_Suc_Counts,wlan_test_result.intWeb_Off_Total_Counts," +
            		"wlan_test_result.intPeap_Auth_Suc_Counts,wlan_test_result.intPeap_Auth_Total_Counts,wlan_test_result.intPeap_Off_Suc_Counts,wlan_test_result.intPeap_Off_Total_Counts,wlan_test_result.intHttp_Req_Suc_Counts," +
            		"wlan_test_result.intHttp_Req_Total_Counts,wlan_test_result.intFtp_Up_Suc_Counts,wlan_test_result.intFtp_UP_Total_Counts,wlan_test_result.intFtp_Down_Suc_Counts,wlan_test_result.intFtp_Down_Total_Counts,wlan_test_result.intUser_Seg_Suc_Counts,wlan_test_result.intUser_Seg_Total_Counts," +
            		"wlan_test_result.intUser_Roam_Suc_Counts,wlan_test_result.intUser_Roam_Total_Counts,wlan_test_result.strApMac,wlan_test_result.strNetType,wlan_test_result.dtCreatDate,wlan_test_result.strCarriers,wlan_test_result.intRssi from wlan_resc_comunity, wlan_test_result,wlan_task_info,wlan_resc_hotpot where wlan_resc_comunity.strcommid = wlan_test_result.strcommunityid and wlan_test_result.strtaskid=wlan_task_info.strtaskid and wlan_task_info.strhotpotname=wlan_resc_hotpot.strid"+ "".concat(where);
         
            Statement s = db.getConnection().createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            if (startRow != 0 && rowCount != 0)
                s.setMaxRows((startRow + rowCount) - 1);
            ResultSet rs = s.executeQuery(sql);
            if (rs != null && rs.next()) {
                if (startRow != 0 && rowCount != 0)
                    rs.absolute(startRow);
                do {
                	Carriers theBean = new Carriers();
                    theBean = load(rs, false);
                    beans.addElement(theBean);
                } while (rs.next());
            }
            rs.close();
            s.close();
        } catch (Exception ee) {
            ee.printStackTrace();
        }
        return beans;
    }
    
    
    public int getCount(String where) {
        int count = 0;
        try {
            String sql = "SELECT count(strId) FROM " + strTableName + "  ";
            if (where.length() > 0) {
                where = where.toLowerCase();
                if (where.indexOf("order") > 0)
                    where = where.substring(0, where.lastIndexOf("order"));
                sql = String.valueOf(sql) + String.valueOf(where);
                //System.out.println("ddddddddddddddddd"+sql);
            }
            ResultSet rs = db.executeQuery(sql);
            if (rs.next())
                count = rs.getInt(1);
            rs.close();
            return count;
        } catch (Exception ee) {
            ee.printStackTrace();
            return count;
        }
    }
    public int getCount1(String where) {
        int count = 0;
        try {
            String sql = "select count(wlan_test_result.strId) from wlan_resc_comunity, wlan_test_result,wlan_task_info,wlan_resc_hotpot where wlan_resc_comunity.strcommid = wlan_test_result.strcommunityid and wlan_test_result.strtaskid=wlan_task_info.strtaskid and wlan_task_info.strhotpotname=wlan_resc_hotpot.strid"+ "  ";
            if (where.length() > 0) {
                where = where.toLowerCase();
                if (where.indexOf("order") > 0)
                    where = where.substring(0, where.lastIndexOf("order"));
                sql = String.valueOf(sql) + String.valueOf(where);
            }
            ResultSet rs = db.executeQuery(sql);
            if (rs.next())
                count = rs.getInt(1);
            rs.close();
            return count;
        } catch (Exception ee) {
            ee.printStackTrace();
            return count;
        }
    }
    
  //*************************拿到19项指标值*******************
    public Carriers show2(String where){
    	Carriers showBean=null;
    	try { 
    		String sql = "select intAp_Relevacy_Sucrate,intAp_Relevacy_Delay,intWeb_Auth_Sucrate,intWeb_Off_Sucrate,intPeap_Auth_Sucrate,intPeap_Off_Sucrate,intHttp_Req_Sucrate,intPing_Sucrate,intFtp_Up_Sucrate,intFtp_Down_Sucrate,intUser_Seg_Sucrate,intUser_Roam_Sucrate,intWeb_Up_Delay,intWeb_Down_Delay,intPeap_Up_Delay,intHttp_Resp_Delay,intPing_Delay,intFtp_Up_Speed,intFtp_Down_Speed,intAp_Corr_Suc_Counts,intAp_Corr_Total_Counts,intWeb_Auth_Suc_Counts,intWeb_Auth_Total_Counts,intWeb_Off_Suc_Counts,intWeb_Off_Total_Counts,intPeap_Auth_Suc_Counts,intPeap_Auth_Total_Counts,intPeap_Off_Suc_Counts,intPeap_Off_Total_Counts,intHttp_Req_Suc_Counts,intHttp_Req_Total_Counts,intFtp_Up_Suc_Counts, intFtp_UP_Total_Counts, intFtp_Down_Suc_Counts, intFtp_Down_Total_Counts, intUser_Seg_Suc_Counts,intUser_Seg_Total_Counts,intUser_Roam_Suc_Counts, intUser_Roam_Total_Counts from " + strTableName + " ";
			sql = String.valueOf(sql) + String.valueOf(where);
			Statement s = db.getConnection().createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
			ResultSet rs = db.executeQuery(sql);
			 if (rs != null && rs.next()){
				 showBean=load2(rs, true);
			 }
		} catch (Exception e) {
			e.printStackTrace();
		}
		return showBean;
    }
    
    //记录集转化为对象
    public Carriers load2(ResultSet rs, boolean isView) {
    	Carriers theBean = new Carriers();
        try {
        	theBean.setIntAp_Relevacy_Sucrate(rs.getDouble("intAp_Relevacy_Sucrate"));
            theBean.setIntAp_Relevacy_Delay(rs.getDouble("intAp_Relevacy_Delay"));
            theBean.setIntWeb_Auth_Sucrate(rs.getDouble("intWeb_Auth_Sucrate"));
            theBean.setIntWeb_Off_Sucrate(rs.getDouble("intWeb_Off_Sucrate"));
            
            theBean.setIntPeap_Auth_Sucrate(rs.getDouble("intPeap_Auth_Sucrate"));
            theBean.setIntPeap_Off_Sucrate(rs.getDouble("intPeap_Off_Sucrate"));
            theBean.setIntHttp_Req_Sucrate(rs.getDouble("intHttp_Req_Sucrate"));
            theBean.setIntPing_Sucrate(rs.getDouble("intPing_Sucrate"));
            theBean.setIntFtp_Up_Sucrate(rs.getDouble("intFtp_Up_Sucrate"));
            
            theBean.setIntFtp_Down_Sucrate(rs.getDouble("intFtp_Down_Sucrate"));
            theBean.setIntUser_Seg_Sucrate(rs.getDouble("intUser_Seg_Sucrate"));
            theBean.setIntUser_Roam_Sucrate(rs.getDouble("intUser_Roam_Sucrate"));
            theBean.setIntWeb_Up_Delay(rs.getDouble("intWeb_Up_Delay"));
            theBean.setIntWeb_Down_Delay(rs.getDouble("intWeb_Down_Delay"));
            
            theBean.setIntPeap_Up_Delay(rs.getDouble("intPeap_Up_Delay"));
            theBean.setIntHttp_Resp_Delay(rs.getDouble("intHttp_Resp_Delay"));
            theBean.setIntPing_Delay(rs.getDouble("intPing_Delay"));
            theBean.setIntFtp_Up_Speed(rs.getDouble("intFtp_Up_Speed"));
            theBean.setIntFtp_Down_Speed(rs.getDouble("intFtp_Down_Speed"));
            
            theBean.setIntAp_Corr_Suc_Counts(rs.getDouble("intAp_Corr_Suc_Counts"));
            theBean.setIntAp_Corr_Total_Counts(rs.getDouble("intAp_Corr_Total_Counts"));
            theBean.setIntWeb_Auth_Suc_Counts(rs.getDouble("intWeb_Auth_Suc_Counts"));
            theBean.setIntWeb_Auth_Total_Counts(rs.getDouble("intWeb_Auth_Total_Counts"));
            theBean.setIntWeb_Off_Suc_Counts(rs.getDouble("intWeb_Off_Suc_Counts"));
           
            theBean.setIntWeb_Off_Total_Counts(rs.getDouble("intWeb_Off_Total_Counts"));
            theBean.setIntPeap_Auth_Suc_Counts(rs.getDouble("intPeap_Auth_Suc_Counts"));
            theBean.setIntPeap_Auth_Total_Counts(rs.getDouble("intPeap_Auth_Total_Counts"));
            theBean.setIntPeap_Off_Suc_Counts(rs.getDouble("intPeap_Off_Suc_Counts"));
            theBean.setIntPeap_Off_Total_Counts(rs.getDouble("intPeap_Off_Total_Counts"));
            
            
            theBean.setIntHttp_Req_Suc_Counts(rs.getDouble("intHttp_Req_Suc_Counts"));
            theBean.setIntHttp_Req_Total_Counts(rs.getDouble("intHttp_Req_Total_Counts"));
            theBean.setIntFtp_Up_Suc_Counts(rs.getDouble("intFtp_Up_Suc_Counts"));
            theBean.setIntFtp_UP_Total_Counts(rs.getDouble("intFtp_UP_Total_Counts"));
            theBean.setIntFtp_Down_Suc_Counts(rs.getDouble("intFtp_Down_Suc_Counts"));
            
            
            theBean.setIntFtp_Down_Total_Counts(rs.getDouble("intFtp_Down_Total_Counts"));
            theBean.setIntUser_Seg_Suc_Counts(rs.getDouble("intUser_Seg_Suc_Counts"));
            theBean.setIntUser_Seg_Total_Counts(rs.getDouble("intUser_Seg_Total_Counts"));
            theBean.setIntUser_Roam_Suc_Counts(rs.getDouble("intUser_Roam_Suc_Counts"));
            theBean.setIntUser_Roam_Total_Counts(rs.getDouble("intUser_Roam_Total_Counts"));
            theBean.setIntRssi(rs.getDouble("intRssi"));
        } catch (Exception e) {
            e.printStackTrace();
        }
        return theBean;
    }
    
    
    //************************获取所有wlan成功率指标**************************
    public Vector<Carriers> returnindex(String where){
    	Vector<Carriers> beans = new Vector<Carriers>();
    	
    	try { 
    		String sql = "select intAp_Relevacy_Sucrate,intAp_Relevacy_Delay,intWeb_Auth_Sucrate,intWeb_Off_Sucrate,intPeap_Auth_Sucrate,intPeap_Off_Sucrate,intHttp_Req_Sucrate,intPing_Sucrate,intFtp_Up_Sucrate,intFtp_Down_Sucrate,intUser_Seg_Sucrate,intUser_Roam_Sucrate,intWeb_Up_Delay,intWeb_Down_Delay,intPeap_Up_Delay,intHttp_Resp_Delay,intPing_Delay,intFtp_Up_Speed,intFtp_Down_Speed,intAp_Corr_Suc_Counts,intAp_Corr_Total_Counts,intWeb_Auth_Suc_Counts,intWeb_Auth_Total_Counts,intWeb_Off_Suc_Counts,intWeb_Off_Total_Counts,intPeap_Auth_Suc_Counts,intPeap_Auth_Total_Counts,intPeap_Off_Suc_Counts,intPeap_Off_Total_Counts,intHttp_Req_Suc_Counts,intHttp_Req_Total_Counts,intFtp_Up_Suc_Counts, intFtp_UP_Total_Counts, intFtp_Down_Suc_Counts, intFtp_Down_Total_Counts, intUser_Seg_Suc_Counts,intUser_Seg_Total_Counts,intUser_Roam_Suc_Counts, intUser_Roam_Total_Counts ,intRssi from " + strTableName + " ";
			sql = String.valueOf(sql) + String.valueOf(where);
			Statement s = db.getConnection().createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
			ResultSet rs = db.executeQuery(sql);
			 if (rs != null && rs.next()){
				 do{
					 Carriers theBean = new Carriers();
                 theBean = load2(rs, false);
                 beans.addElement(theBean);
				 }while(rs.next());
			 }
			 rs.close();
	            s.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return beans;
    }
   
    
    public Vector<Carriers> listcity() {
		Vector<Carriers> beans = new Vector<Carriers>();
        try {
            String sql = "select distinct(strcity) from " +strTableName1+"  "; 
          
            Statement s = db.getConnection().createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            
            ResultSet rs = s.executeQuery(sql);
            if (rs != null && rs.next()) {
               
                do {
                	Carriers theBean = new Carriers();
                    theBean = loadcity(rs, false);
                    beans.addElement(theBean);
                } while (rs.next());
            }
            rs.close();
            s.close();
        } catch (Exception ee) {
            ee.printStackTrace();
        }
        return beans;
    }
    public Carriers loadcity(ResultSet rs,boolean isView){
    	Carriers smLoad = new Carriers();
  		try {
  			smLoad.setStrcity(rs.getString("strCity"));
  		} catch (Exception e){
  			e.printStackTrace();
  		}
  		return smLoad;
  	}
    public Carriers show3(String where ){
    	Carriers showBean=null;
    	try { 
    		String sql = "select strcity,strtown,strSiteName,strSiteType,strLac,strCI from " + strTableName2 + "  ";
			sql = String.valueOf(sql) + String.valueOf(where);
			Statement s = db.getConnection().createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
			ResultSet rs = db.executeQuery(sql);
			 if (rs != null && rs.next()){
				 showBean=load4(rs, true);
			 }
		} catch (Exception e) {
			e.printStackTrace();
		}
		return showBean;
    }
    public Carriers load4(ResultSet rs, boolean isView) {
    	Carriers theBean = new Carriers();
        try {
        	theBean.setStrcity1(rs.getString("strcity"));
            theBean.setStrtown1(rs.getString("strtown"));
            theBean.setStrSiteName(rs.getString("strSiteName"));
            theBean.setStrSiteType(rs.getString("strSiteType"));
            theBean.setStrLac(rs.getString("strLac"));
            theBean.setStrCI(rs.getString("strCI"));
           
        } catch (Exception e) {
            e.printStackTrace();
        }
        return theBean;
    }
    public Vector<Carriers> listcomunity(String where, int startRow, int rowCount) {
		Vector<Carriers> beans = new Vector<Carriers>();
        try {
            String sql = "select strcity,strtown,strSiteName,strSiteType,strLac,strCI from  wlan_resc_comunity  "+ "".concat(where);
         
            Statement s = db.getConnection().createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            if (startRow != 0 && rowCount != 0)
                s.setMaxRows((startRow + rowCount) - 1);
            ResultSet rs = s.executeQuery(sql);
            if (rs != null && rs.next()) {
                if (startRow != 0 && rowCount != 0)
                    rs.absolute(startRow);
                do {
                	Carriers theBean = new Carriers();
                    theBean = load4(rs, false);
                    beans.addElement(theBean);
                } while (rs.next());
            }
            rs.close();
            s.close();
        } catch (Exception ee) {
            ee.printStackTrace();
        }
        return beans;
    }
    public int getCount2(String where) {
        int count = 0;
        try {
            String sql = "SELECT count(strcommId) FROM " + strTableName2 + "  ";
            if (where.length() > 0) {
                where = where.toLowerCase();
                if (where.indexOf("order") > 0)
                    where = where.substring(0, where.lastIndexOf("order"));
                sql = String.valueOf(sql) + String.valueOf(where);
            }
            ResultSet rs = db.executeQuery(sql);
            if (rs.next())
                count = rs.getInt(1);
            rs.close();
            return count;
        } catch (Exception ee) {
            ee.printStackTrace();
            return count;
        }
    }
    //********************************************************************
    private String strTableName = "wlan_test_result";
    private String strTableName1 = "wlan_resc_hotpot";
    private String strTableName2 = "wlan_resc_comunity";
    private String strId;  
    private String strTaskId;  
    private String strCommunityId;  
    private String strNeiCommunityId;
    
    private String strText;
    private double intAp_Relevacy_Sucrate;
    private double intAp_Relevacy_Delay;
    private double intWeb_Auth_Sucrate;
    private double intWeb_Off_Sucrate;
    
    private double intPeap_Auth_Sucrate;
    private double intPeap_Off_Sucrate;
    private double intHttp_Req_Sucrate;
    private double intPing_Sucrate;
    private double intFtp_Up_Sucrate;
    
    private double intFtp_Down_Sucrate;
    private double intUser_Seg_Sucrate;
    private double intUser_Roam_Sucrate;
    private double intWeb_Up_Delay;
    private double intWeb_Down_Delay;
    
    private double intPeap_Up_Delay;
    private double intHttp_Resp_Delay;
    private double intPing_Delay;
    private double intFtp_Up_Speed;
    private double intFtp_Down_Speed;
    
    private double intAp_Corr_Suc_Counts;
    private double intAp_Corr_Total_Counts;
    private double intWeb_Auth_Suc_Counts;
    private double intWeb_Auth_Total_Counts;
    private double intWeb_Off_Suc_Counts;
    
    private double intWeb_Off_Total_Counts;
    private double intPeap_Auth_Suc_Counts;
    private double intPeap_Auth_Total_Counts;
    private double intPeap_Off_Suc_Counts;
    private double intPeap_Off_Total_Counts;
    
    private double intHttp_Req_Suc_Counts;
    private double intHttp_Req_Total_Counts;
    private double intFtp_Up_Suc_Counts;
    private double intFtp_UP_Total_Counts;
    private double intFtp_Down_Suc_Counts;
    
    private double intFtp_Down_Total_Counts;
    private double intUser_Seg_Suc_Counts;
    private double intUser_Seg_Total_Counts;
    private double intUser_Roam_Suc_Counts;
    private double intUser_Roam_Total_Counts;
    
    private double intPing_Total_Counts;
    private double intPing_Suc_Counts;
    private double intRssi;
    
    private String strApMac;
    private String strNetType;
    private String dtCreatDate;
    private String strCarriers;
    private String strcity1;
    private String strtown1;
    private String strSiteName;//站名
    private String strSiteType;//站型
    private String strLac;//位置区码
    private String strCI;//小区识别
    public String getStrSiteName() {
		return strSiteName;
	}

	public void setStrSiteName(String strSiteName) {
		this.strSiteName = strSiteName;
	}

	public String getStrSiteType() {
		return strSiteType;
	}

	public void setStrSiteType(String strSiteType) {
		this.strSiteType = strSiteType;
	}

	public String getStrLac() {
		return strLac;
	}

	public void setStrLac(String strLac) {
		this.strLac = strLac;
	}

	public String getStrCI() {
		return strCI;
	}

	public void setStrCI(String strCI) {
		this.strCI = strCI;
	}

	public String getStrcity1() {
		return strcity1;
	}

	public void setStrcity1(String strcity1) {
		this.strcity1 = strcity1;
	}
	
    
    public String getStrtown1() {
		return strtown1;
	}

	public void setStrtown1(String strtown1) {
		this.strtown1 = strtown1;
	}
	//**********获取地市*****************
    private String strcity;
  //**********获取地市*****************
    
    
    public double getIntPing_Total_Counts() {
		return intPing_Total_Counts;
	}

	public void setIntPing_Total_Counts(double intPingTotalCounts) {
		intPing_Total_Counts = intPingTotalCounts;
	}

	public double getIntPing_Suc_Counts() {
		return intPing_Suc_Counts;
	}

	public void setIntPing_Suc_Counts(double intPingSucCounts) {
		intPing_Suc_Counts = intPingSucCounts;
	}

	public double getIntRssi() {
		return intRssi;
	}

	public void setIntRssi(double intRssi) {
		this.intRssi = intRssi;
	}

	public String getStrcity() {
		return strcity;
	}

	public void setStrcity(String strcity) {
		this.strcity = strcity;
	}

	public double getIntHttp_Req_Total_Counts() {
		return intHttp_Req_Total_Counts;
	}

	public void setIntHttp_Req_Total_Counts(double intHttpReqTotalCounts) {
		intHttp_Req_Total_Counts = intHttpReqTotalCounts;
	}

	public String getStrId() {
		return strId;
	}

	public void setStrId(String strId) {
		this.strId = strId;
	}

	public String getStrTaskId() {
		return strTaskId;
	}

	public void setStrTaskId(String strTaskId) {
		this.strTaskId = strTaskId;
	}

	public String getStrCommunityId() {
		return strCommunityId;
	}

	public void setStrCommunityId(String strCommunityId) {
		this.strCommunityId = strCommunityId;
	}

	public String getStrNeiCommunityId() {
		return strNeiCommunityId;
	}

	public void setStrNeiCommunityId(String strNeiCommunityId) {
		this.strNeiCommunityId = strNeiCommunityId;
	}

	public String getStrText() {
		return strText;
	}

	public void setStrText(String strText) {
		this.strText = strText;
	}

	public double getIntAp_Relevacy_Sucrate() {
		return intAp_Relevacy_Sucrate;
	}

	public void setIntAp_Relevacy_Sucrate(double intApRelevacySucrate) {
		intAp_Relevacy_Sucrate = intApRelevacySucrate;
	}

	public double getIntAp_Relevacy_Delay() {
		return intAp_Relevacy_Delay;
	}

	public void setIntAp_Relevacy_Delay(double intApRelevacyDelay) {
		intAp_Relevacy_Delay = intApRelevacyDelay;
	}

	public double getIntWeb_Auth_Sucrate() {
		return intWeb_Auth_Sucrate;
	}

	public void setIntWeb_Auth_Sucrate(double intWebAuthSucrate) {
		intWeb_Auth_Sucrate = intWebAuthSucrate;
	}

	public double getIntWeb_Off_Sucrate() {
		return intWeb_Off_Sucrate;
	}

	public void setIntWeb_Off_Sucrate(double intWebOffSucrate) {
		intWeb_Off_Sucrate = intWebOffSucrate;
	}

	public double getIntPeap_Auth_Sucrate() {
		return intPeap_Auth_Sucrate;
	}

	public void setIntPeap_Auth_Sucrate(double intPeapAuthSucrate) {
		intPeap_Auth_Sucrate = intPeapAuthSucrate;
	}

	public double getIntPeap_Off_Sucrate() {
		return intPeap_Off_Sucrate;
	}

	public void setIntPeap_Off_Sucrate(double intPeapOffSucrate) {
		intPeap_Off_Sucrate = intPeapOffSucrate;
	}

	public double getIntHttp_Req_Sucrate() {
		return intHttp_Req_Sucrate;
	}

	public void setIntHttp_Req_Sucrate(double intHttpReqSucrate) {
		intHttp_Req_Sucrate = intHttpReqSucrate;
	}

	public double getIntPing_Sucrate() {
		return intPing_Sucrate;
	}

	public void setIntPing_Sucrate(double intPingSucrate) {
		intPing_Sucrate = intPingSucrate;
	}

	public double getIntFtp_Up_Sucrate() {
		return intFtp_Up_Sucrate;
	}

	public void setIntFtp_Up_Sucrate(double intFtpUpSucrate) {
		intFtp_Up_Sucrate = intFtpUpSucrate;
	}

	public double getIntFtp_Down_Sucrate() {
		return intFtp_Down_Sucrate;
	}

	public void setIntFtp_Down_Sucrate(double intFtpDownSucrate) {
		intFtp_Down_Sucrate = intFtpDownSucrate;
	}

	public double getIntUser_Seg_Sucrate() {
		return intUser_Seg_Sucrate;
	}

	public void setIntUser_Seg_Sucrate(double intUserSegSucrate) {
		intUser_Seg_Sucrate = intUserSegSucrate;
	}

	public double getIntUser_Roam_Sucrate() {
		return intUser_Roam_Sucrate;
	}

	public void setIntUser_Roam_Sucrate(double intUserRoamSucrate) {
		intUser_Roam_Sucrate = intUserRoamSucrate;
	}

	public double getIntWeb_Up_Delay() {
		return intWeb_Up_Delay;
	}

	public void setIntWeb_Up_Delay(double intWebUpDelay) {
		intWeb_Up_Delay = intWebUpDelay;
	}

	public double getIntWeb_Down_Delay() {
		return intWeb_Down_Delay;
	}

	public void setIntWeb_Down_Delay(double intWebDownDelay) {
		intWeb_Down_Delay = intWebDownDelay;
	}

	public double getIntPeap_Up_Delay() {
		return intPeap_Up_Delay;
	}

	public void setIntPeap_Up_Delay(double intPeapUpDelay) {
		intPeap_Up_Delay = intPeapUpDelay;
	}

	public double getIntHttp_Resp_Delay() {
		return intHttp_Resp_Delay;
	}

	public void setIntHttp_Resp_Delay(double intHttpRespDelay) {
		intHttp_Resp_Delay = intHttpRespDelay;
	}

	public double getIntPing_Delay() {
		return intPing_Delay;
	}

	public void setIntPing_Delay(double intPingDelay) {
		intPing_Delay = intPingDelay;
	}

	public double getIntFtp_Up_Speed() {
		return intFtp_Up_Speed;
	}

	public void setIntFtp_Up_Speed(double intFtpUpSpeed) {
		intFtp_Up_Speed = intFtpUpSpeed;
	}

	public double getIntFtp_Down_Speed() {
		return intFtp_Down_Speed;
	}

	public void setIntFtp_Down_Speed(double intFtpDownSpeed) {
		intFtp_Down_Speed = intFtpDownSpeed;
	}

	public double getIntAp_Corr_Suc_Counts() {
		return intAp_Corr_Suc_Counts;
	}

	public void setIntAp_Corr_Suc_Counts(double intApCorrSucCounts) {
		intAp_Corr_Suc_Counts = intApCorrSucCounts;
	}

	public double getIntAp_Corr_Total_Counts() {
		return intAp_Corr_Total_Counts;
	}

	public void setIntAp_Corr_Total_Counts(double intApCorrTotalCounts) {
		intAp_Corr_Total_Counts = intApCorrTotalCounts;
	}

	public double getIntWeb_Auth_Suc_Counts() {
		return intWeb_Auth_Suc_Counts;
	}

	public void setIntWeb_Auth_Suc_Counts(double intWebAuthSucCounts) {
		intWeb_Auth_Suc_Counts = intWebAuthSucCounts;
	}

	public double getIntWeb_Auth_Total_Counts() {
		return intWeb_Auth_Total_Counts;
	}

	public void setIntWeb_Auth_Total_Counts(double intWebAuthTotalCounts) {
		intWeb_Auth_Total_Counts = intWebAuthTotalCounts;
	}

	public double getIntWeb_Off_Suc_Counts() {
		return intWeb_Off_Suc_Counts;
	}

	public void setIntWeb_Off_Suc_Counts(double intWebOffSucCounts) {
		intWeb_Off_Suc_Counts = intWebOffSucCounts;
	}

	public double getIntWeb_Off_Total_Counts() {
		return intWeb_Off_Total_Counts;
	}

	public void setIntWeb_Off_Total_Counts(double intWebOffTotalCounts) {
		intWeb_Off_Total_Counts = intWebOffTotalCounts;
	}

	public double getIntPeap_Auth_Suc_Counts() {
		return intPeap_Auth_Suc_Counts;
	}

	public void setIntPeap_Auth_Suc_Counts(double intPeapAuthSucCounts) {
		intPeap_Auth_Suc_Counts = intPeapAuthSucCounts;
	}

	public double getIntPeap_Auth_Total_Counts() {
		return intPeap_Auth_Total_Counts;
	}

	public void setIntPeap_Auth_Total_Counts(double intPeapAuthTotalCounts) {
		intPeap_Auth_Total_Counts = intPeapAuthTotalCounts;
	}

	public double getIntPeap_Off_Suc_Counts() {
		return intPeap_Off_Suc_Counts;
	}

	public void setIntPeap_Off_Suc_Counts(double intPeapOffSucCounts) {
		intPeap_Off_Suc_Counts = intPeapOffSucCounts;
	}

	public double getIntPeap_Off_Total_Counts() {
		return intPeap_Off_Total_Counts;
	}

	public void setIntPeap_Off_Total_Counts(double intPeapOffTotalCounts) {
		intPeap_Off_Total_Counts = intPeapOffTotalCounts;
	}

	

	public double getIntHttp_Req_Suc_Counts() {
		return intHttp_Req_Suc_Counts;
	}

	public void setIntHttp_Req_Suc_Counts(double intHttpReqSucCounts) {
		intHttp_Req_Suc_Counts = intHttpReqSucCounts;
	}

	

	public double getIntFtp_Up_Suc_Counts() {
		return intFtp_Up_Suc_Counts;
	}

	public void setIntFtp_Up_Suc_Counts(double intFtpUpSucCounts) {
		intFtp_Up_Suc_Counts = intFtpUpSucCounts;
	}

	public double getIntFtp_UP_Total_Counts() {
		return intFtp_UP_Total_Counts;
	}

	public void setIntFtp_UP_Total_Counts(double intFtpUPTotalCounts) {
		intFtp_UP_Total_Counts = intFtpUPTotalCounts;
	}

	public double getIntFtp_Down_Suc_Counts() {
		return intFtp_Down_Suc_Counts;
	}

	public void setIntFtp_Down_Suc_Counts(double intFtpDownSucCounts) {
		intFtp_Down_Suc_Counts = intFtpDownSucCounts;
	}

	public double getIntFtp_Down_Total_Counts() {
		return intFtp_Down_Total_Counts;
	}

	public void setIntFtp_Down_Total_Counts(double intFtpDownTotalCounts) {
		intFtp_Down_Total_Counts = intFtpDownTotalCounts;
	}

	public double getIntUser_Seg_Suc_Counts() {
		return intUser_Seg_Suc_Counts;
	}

	public void setIntUser_Seg_Suc_Counts(double intUserSegSucCounts) {
		intUser_Seg_Suc_Counts = intUserSegSucCounts;
	}

	public double getIntUser_Seg_Total_Counts() {
		return intUser_Seg_Total_Counts;
	}

	public void setIntUser_Seg_Total_Counts(double intUserSegTotalCounts) {
		intUser_Seg_Total_Counts = intUserSegTotalCounts;
	}

	public double getIntUser_Roam_Suc_Counts() {
		return intUser_Roam_Suc_Counts;
	}

	public void setIntUser_Roam_Suc_Counts(double intUserRoamSucCounts) {
		intUser_Roam_Suc_Counts = intUserRoamSucCounts;
	}

	public double getIntUser_Roam_Total_Counts() {
		return intUser_Roam_Total_Counts;
	}

	public void setIntUser_Roam_Total_Counts(double intUserRoamTotalCounts) {
		intUser_Roam_Total_Counts = intUserRoamTotalCounts;
	}

	public String getStrApMac() {
		return strApMac;
	}

	public void setStrApMac(String strApMac) {
		this.strApMac = strApMac;
	}

	public String getStrNetType() {
		return strNetType;
	}

	public void setStrNetType(String strNetType) {
		this.strNetType = strNetType;
	}

	public String getDtCreatDate() {
		return dtCreatDate;
	}

	public void setDtCreatDate(String dtCreatDate) {
		this.dtCreatDate = dtCreatDate;
	}

	public String getStrCarriers() {
		return strCarriers;
	}

	public void setStrCarriers(String strCarriers) {
		this.strCarriers = strCarriers;
	}

	public Globa getGloba() {
		return globa;
	}

	public void setGloba(Globa globa) {
		this.globa = globa;
	}

	public DbConnect getDb() {
		return db;
	}

	public void setDb(DbConnect db) {
		this.db = db;
	}

	
    
}